﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="OSDK" targetNamespace="http://tempuri.org/OSDK.xsd" xmlns:mstns="http://tempuri.org/OSDK.xsd" xmlns="http://tempuri.org/OSDK.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="osdkConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="osdkConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.osdkConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UTBILDNINGSNIVATableAdapter" GeneratorDataComponentClassName="UTBILDNINGSNIVATableAdapter" Name="UTBILDNINGSNIVA" UserDataComponentName="UTBILDNINGSNIVATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectName="osdk.dbo.UTBILDNINGSNIVA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[UTBILDNINGSNIVA] WHERE (([UtbildningsNiva] = @Original_UtbildningsNiva))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UtbildningsNiva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UtbildningsNiva" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[UTBILDNINGSNIVA] ([UtbildningsNiva], [Beskrivning], [Short]) VALUES (@UtbildningsNiva, @Beskrivning, @Short)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UtbildningsNiva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UtbildningsNiva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Beskrivning" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Beskrivning" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Short" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Short" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UtbildningsNiva, Beskrivning, Short FROM dbo.UTBILDNINGSNIVA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[UTBILDNINGSNIVA] SET [UtbildningsNiva] = @UtbildningsNiva, [Beskrivning] = @Beskrivning, [Short] = @Short WHERE (([UtbildningsNiva] = @Original_UtbildningsNiva))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UtbildningsNiva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UtbildningsNiva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Beskrivning" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Beskrivning" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Short" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Short" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UtbildningsNiva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UtbildningsNiva" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UtbildningsNiva" DataSetColumn="UtbildningsNiva" />
              <Mapping SourceColumn="Beskrivning" DataSetColumn="Beskrivning" />
              <Mapping SourceColumn="Short" DataSetColumn="Short" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MEDLEMSTYPTableAdapter" GeneratorDataComponentClassName="MEDLEMSTYPTableAdapter" Name="MEDLEMSTYP" UserDataComponentName="MEDLEMSTYPTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectName="osdk.dbo.MEDLEMSTYP" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[MEDLEMSTYP] WHERE (([MedlemsTyp] = @Original_MedlemsTyp))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MedlemsTyp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MedlemsTyp" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[MEDLEMSTYP] ([MedlemsTyp], [Beskrivning], [Avgift], [Short]) VALUES (@MedlemsTyp, @Beskrivning, @Avgift, @Short)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MedlemsTyp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MedlemsTyp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Beskrivning" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Beskrivning" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Avgift" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Avgift" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Short" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Short" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MedlemsTyp, Beskrivning, Avgift, Short FROM dbo.MEDLEMSTYP</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[MEDLEMSTYP] SET [MedlemsTyp] = @MedlemsTyp, [Beskrivning] = @Beskrivning, [Avgift] = @Avgift, [Short] = @Short WHERE (([MedlemsTyp] = @Original_MedlemsTyp))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MedlemsTyp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MedlemsTyp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Beskrivning" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Beskrivning" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Avgift" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Avgift" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Short" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Short" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MedlemsTyp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MedlemsTyp" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MedlemsTyp" DataSetColumn="MedlemsTyp" />
              <Mapping SourceColumn="Beskrivning" DataSetColumn="Beskrivning" />
              <Mapping SourceColumn="Avgift" DataSetColumn="Avgift" />
              <Mapping SourceColumn="Short" DataSetColumn="Short" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SSDFKATEGORITableAdapter" GeneratorDataComponentClassName="SSDFKATEGORITableAdapter" Name="SSDFKATEGORI" UserDataComponentName="SSDFKATEGORITableAdapter">
            <MainSource>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectName="osdk.dbo.SSDFKATEGORI" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SSDFKATEGORI] WHERE (([SSDFKategori] = @Original_SSDFKategori))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SSDFKategori" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SSDFKategori" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SSDFKATEGORI] ([SSDFKategori], [Beskrivning], [Avgift]) VALUES (@SSDFKategori, @Beskrivning, @Avgift)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SSDFKategori" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SSDFKategori" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Beskrivning" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Beskrivning" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Avgift" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Avgift" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SSDFKategori, Beskrivning, Avgift FROM dbo.SSDFKATEGORI</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SSDFKATEGORI] SET [SSDFKategori] = @SSDFKategori, [Beskrivning] = @Beskrivning, [Avgift] = @Avgift WHERE (([SSDFKategori] = @Original_SSDFKategori))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SSDFKategori" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SSDFKategori" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Beskrivning" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Beskrivning" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Avgift" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Avgift" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SSDFKategori" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SSDFKategori" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SSDFKategori" DataSetColumn="SSDFKategori" />
              <Mapping SourceColumn="Beskrivning" DataSetColumn="Beskrivning" />
              <Mapping SourceColumn="Avgift" DataSetColumn="Avgift" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmailTableAdapter" GeneratorDataComponentClassName="EmailTableAdapter" Name="Email" UserDataComponentName="EmailTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectName="osdk.dbo.MEDLEM" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Email
FROM            dbo.MEDLEM
WHERE        (Email &lt;&gt; '') AND (Betalt = 1) AND (Inaktiv = 0)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectName="osdk.dbo.MEDLEM" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFunktionärer" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByFunktionärer" GeneratorSourceName="FillByFunktionärer" GetMethodModifier="Public" GetMethodName="GetDataByFunktionärer" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByFunktionärer" UserSourceName="FillByFunktionärer">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Email
FROM            dbo.MEDLEM
WHERE        (Email &lt;&gt; '') AND (Betalt = 1) AND (Inaktiv = 0) AND (Funktionar = 1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="REL_MEDLEM_UTBILDNINGSNIVATableAdapter" GeneratorDataComponentClassName="REL_MEDLEM_UTBILDNINGSNIVATableAdapter" Name="REL_MEDLEM_UTBILDNINGSNIVA" UserDataComponentName="REL_MEDLEM_UTBILDNINGSNIVATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectName="Osdk_Temp.db_owner.REL_MEDLEM_UTBILDNINGSNIVA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [db_owner].[REL_MEDLEM_UTBILDNINGSNIVA] ([Medlemsnr], [UtbildningsNiva]) VALUES (@Medlemsnr, @UtbildningsNiva)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Medlemsnr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medlemsnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UtbildningsNiva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UtbildningsNiva" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Medlemsnr, UtbildningsNiva FROM db_owner.REL_MEDLEM_UTBILDNINGSNIVA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Medlemsnr" DataSetColumn="Medlemsnr" />
              <Mapping SourceColumn="UtbildningsNiva" DataSetColumn="UtbildningsNiva" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MEDLEMTableAdapter" GeneratorDataComponentClassName="MEDLEMTableAdapter" Name="MEDLEM" UserDataComponentName="MEDLEMTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectName="Osdk_Temp.dbo.MEDLEM" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[MEDLEM] WHERE (([Medlemsnr] = @Original_Medlemsnr))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Medlemsnr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medlemsnr" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[MEDLEM] ([Medlemsnr], [Streckkod], [Efternamn], [Förnamn], [Adress], [Postnr], [Postadress], [Telefonnr], [Telefonnr2], [Personnummer], [Medlemstyp], [Email], [Betalt], [BetaltDatum], [SSDFKategori], [Uppdrag], [IntradesDatum], [Region], [Kommentar], [Kön], [Inaktiv], [Utskick], [Andrad], [Skapad], [Funktionar], [AndradAv], [Betalt2003], [Betalt2004], [Betalt2005], [Betalt2006], [Betalt2007], [Betalt2008], [N3SportID]) VALUES (@Medlemsnr, @Streckkod, @Efternamn, @Förnamn, @Adress, @Postnr, @Postadress, @Telefonnr, @Telefonnr2, @Personnummer, @Medlemstyp, @Email, @Betalt, @BetaltDatum, @SSDFKategori, @Uppdrag, @IntradesDatum, @Region, @Kommentar, @Kön, @Inaktiv, @Utskick, @Andrad, @Skapad, @Funktionar, @AndradAv, @Betalt2003, @Betalt2004, @Betalt2005, @Betalt2006, @Betalt2007, @Betalt2008, @N3SportID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Medlemsnr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medlemsnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Streckkod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Streckkod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Efternamn" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Efternamn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Förnamn" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Förnamn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Postnr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Postnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Postadress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Postadress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefonnr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefonnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefonnr2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefonnr2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Personnummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Personnummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Medlemstyp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medlemstyp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BetaltDatum" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="BetaltDatum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SSDFKategori" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SSDFKategori" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Uppdrag" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Uppdrag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@IntradesDatum" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="IntradesDatum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Region" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Region" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Kommentar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kommentar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Kön" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kön" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Inaktiv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Inaktiv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Utskick" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Utskick" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Andrad" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Andrad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Skapad" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Skapad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Funktionar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Funktionar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AndradAv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AndradAv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2003" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2003" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2004" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2004" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2005" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2005" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2006" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2006" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2007" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2007" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2008" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2008" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@N3SportID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="N3SportID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Medlemsnr, Streckkod, Efternamn, Förnamn, Adress, Postnr, Postadress, Telefonnr, Telefonnr2, Personnummer, Medlemstyp, Email, Betalt, BetaltDatum, SSDFKategori, Uppdrag, IntradesDatum, Region, Kommentar, Kön, Inaktiv, Utskick, Andrad, Skapad, Funktionar, AndradAv, Betalt2003, Betalt2004, Betalt2005, Betalt2006, Betalt2007, Betalt2008, N3SportID FROM dbo.MEDLEM</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[MEDLEM] SET [Medlemsnr] = @Medlemsnr, [Streckkod] = @Streckkod, [Efternamn] = @Efternamn, [Förnamn] = @Förnamn, [Adress] = @Adress, [Postnr] = @Postnr, [Postadress] = @Postadress, [Telefonnr] = @Telefonnr, [Telefonnr2] = @Telefonnr2, [Personnummer] = @Personnummer, [Medlemstyp] = @Medlemstyp, [Email] = @Email, [Betalt] = @Betalt, [BetaltDatum] = @BetaltDatum, [SSDFKategori] = @SSDFKategori, [Uppdrag] = @Uppdrag, [IntradesDatum] = @IntradesDatum, [Region] = @Region, [Kommentar] = @Kommentar, [Kön] = @Kön, [Inaktiv] = @Inaktiv, [Utskick] = @Utskick, [Andrad] = @Andrad, [Skapad] = @Skapad, [Funktionar] = @Funktionar, [AndradAv] = @AndradAv, [Betalt2003] = @Betalt2003, [Betalt2004] = @Betalt2004, [Betalt2005] = @Betalt2005, [Betalt2006] = @Betalt2006, [Betalt2007] = @Betalt2007, [Betalt2008] = @Betalt2008, [N3SportID] = @N3SportID WHERE (([Medlemsnr] = @Original_Medlemsnr))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Medlemsnr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medlemsnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Streckkod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Streckkod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Efternamn" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Efternamn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Förnamn" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Förnamn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Postnr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Postnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Postadress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Postadress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefonnr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefonnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefonnr2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefonnr2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Personnummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Personnummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Medlemstyp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medlemstyp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BetaltDatum" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="BetaltDatum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SSDFKategori" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SSDFKategori" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Uppdrag" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Uppdrag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@IntradesDatum" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="IntradesDatum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Region" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Region" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Kommentar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kommentar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Kön" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kön" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Inaktiv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Inaktiv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Utskick" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Utskick" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Andrad" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Andrad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Skapad" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Skapad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Funktionar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Funktionar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AndradAv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AndradAv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2003" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2003" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2004" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2004" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2005" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2005" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2006" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2006" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2007" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2007" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Betalt2008" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Betalt2008" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@N3SportID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="N3SportID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Medlemsnr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medlemsnr" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Medlemsnr" DataSetColumn="Medlemsnr" />
              <Mapping SourceColumn="Streckkod" DataSetColumn="Streckkod" />
              <Mapping SourceColumn="Efternamn" DataSetColumn="Efternamn" />
              <Mapping SourceColumn="Förnamn" DataSetColumn="Förnamn" />
              <Mapping SourceColumn="Adress" DataSetColumn="Adress" />
              <Mapping SourceColumn="Postnr" DataSetColumn="Postnr" />
              <Mapping SourceColumn="Postadress" DataSetColumn="Postadress" />
              <Mapping SourceColumn="Telefonnr" DataSetColumn="Telefonnr" />
              <Mapping SourceColumn="Telefonnr2" DataSetColumn="Telefonnr2" />
              <Mapping SourceColumn="Personnummer" DataSetColumn="Personnummer" />
              <Mapping SourceColumn="Medlemstyp" DataSetColumn="Medlemstyp" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Betalt" DataSetColumn="Betalt" />
              <Mapping SourceColumn="BetaltDatum" DataSetColumn="BetaltDatum" />
              <Mapping SourceColumn="SSDFKategori" DataSetColumn="SSDFKategori" />
              <Mapping SourceColumn="Uppdrag" DataSetColumn="Uppdrag" />
              <Mapping SourceColumn="IntradesDatum" DataSetColumn="IntradesDatum" />
              <Mapping SourceColumn="Region" DataSetColumn="Region" />
              <Mapping SourceColumn="Kommentar" DataSetColumn="Kommentar" />
              <Mapping SourceColumn="Kön" DataSetColumn="Kön" />
              <Mapping SourceColumn="Inaktiv" DataSetColumn="Inaktiv" />
              <Mapping SourceColumn="Utskick" DataSetColumn="Utskick" />
              <Mapping SourceColumn="Andrad" DataSetColumn="Andrad" />
              <Mapping SourceColumn="Skapad" DataSetColumn="Skapad" />
              <Mapping SourceColumn="Funktionar" DataSetColumn="Funktionar" />
              <Mapping SourceColumn="AndradAv" DataSetColumn="AndradAv" />
              <Mapping SourceColumn="Betalt2003" DataSetColumn="Betalt2003" />
              <Mapping SourceColumn="Betalt2004" DataSetColumn="Betalt2004" />
              <Mapping SourceColumn="Betalt2005" DataSetColumn="Betalt2005" />
              <Mapping SourceColumn="Betalt2006" DataSetColumn="Betalt2006" />
              <Mapping SourceColumn="Betalt2007" DataSetColumn="Betalt2007" />
              <Mapping SourceColumn="Betalt2008" DataSetColumn="Betalt2008" />
              <Mapping SourceColumn="N3SportID" DataSetColumn="N3SportID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MatrikelMedlemTableAdapter" GeneratorDataComponentClassName="MatrikelMedlemTableAdapter" Name="MatrikelMedlem" UserDataComponentName="MatrikelMedlemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        dbo.MEDLEM.Medlemsnr, dbo.MEDLEM.Efternamn, dbo.MEDLEM.Förnamn, dbo.MEDLEM.Adress, dbo.MEDLEM.Postnr, dbo.MEDLEM.Postadress, 
                         dbo.MEDLEM.Telefonnr, dbo.MEDLEM.Telefonnr2, dbo.MEDLEM.Email, dbo.MEDLEM.Uppdrag, dbo.MEDLEMSTYP.Beskrivning AS MEDLEMSTYP, 
                         dbo.SSDFKATEGORI.Beskrivning AS SSDFKATEGORI
FROM            dbo.MEDLEM INNER JOIN
                         dbo.MEDLEMSTYP ON dbo.MEDLEM.Medlemstyp = dbo.MEDLEMSTYP.MedlemsTyp AND 
                         dbo.MEDLEM.Medlemstyp = dbo.MEDLEMSTYP.MedlemsTyp INNER JOIN
                         dbo.SSDFKATEGORI ON dbo.MEDLEM.SSDFKategori = dbo.SSDFKATEGORI.SSDFKategori AND 
                         dbo.MEDLEM.SSDFKategori = dbo.SSDFKATEGORI.SSDFKategori
WHERE        (dbo.MEDLEM.Betalt = 1) AND (dbo.MEDLEM.Inaktiv = 0)
ORDER BY dbo.MEDLEM.Efternamn, dbo.MEDLEM.Förnamn</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MEDLEMSTYP" DataSetColumn="MEDLEMSTYP" />
              <Mapping SourceColumn="SSDFKATEGORI" DataSetColumn="SSDFKATEGORI" />
              <Mapping SourceColumn="Efternamn" DataSetColumn="Efternamn" />
              <Mapping SourceColumn="Förnamn" DataSetColumn="Förnamn" />
              <Mapping SourceColumn="Adress" DataSetColumn="Adress" />
              <Mapping SourceColumn="Postnr" DataSetColumn="Postnr" />
              <Mapping SourceColumn="Postadress" DataSetColumn="Postadress" />
              <Mapping SourceColumn="Telefonnr" DataSetColumn="Telefonnr" />
              <Mapping SourceColumn="Telefonnr2" DataSetColumn="Telefonnr2" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Uppdrag" DataSetColumn="Uppdrag" />
              <Mapping SourceColumn="Medlemsnr" DataSetColumn="Medlemsnr" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MatrikelUtbildningsnivaTableAdapter" GeneratorDataComponentClassName="MatrikelUtbildningsnivaTableAdapter" Name="MatrikelUtbildningsniva" UserDataComponentName="MatrikelUtbildningsnivaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectName="Osdk_Temp.dbo.UTBILDNINGSNIVA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        dbo.UTBILDNINGSNIVA.Beskrivning, dbo.UTBILDNINGSNIVA.Short
FROM            dbo.MEDLEM INNER JOIN
                         REL_MEDLEM_UTBILDNINGSNIVA ON dbo.MEDLEM.Medlemsnr = REL_MEDLEM_UTBILDNINGSNIVA.Medlemsnr AND 
                         dbo.MEDLEM.Medlemsnr = REL_MEDLEM_UTBILDNINGSNIVA.Medlemsnr AND 
                         dbo.MEDLEM.Medlemsnr = REL_MEDLEM_UTBILDNINGSNIVA.Medlemsnr INNER JOIN
                         dbo.UTBILDNINGSNIVA ON REL_MEDLEM_UTBILDNINGSNIVA.UtbildningsNiva = dbo.UTBILDNINGSNIVA.UtbildningsNiva AND 
                         REL_MEDLEM_UTBILDNINGSNIVA.UtbildningsNiva = dbo.UTBILDNINGSNIVA.UtbildningsNiva AND 
                         REL_MEDLEM_UTBILDNINGSNIVA.UtbildningsNiva = dbo.UTBILDNINGSNIVA.UtbildningsNiva
WHERE        (dbo.MEDLEM.Medlemsnr = @Medlemsnr)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Medlemsnr" ColumnName="Medlemsnr" DataSourceName="Osdk_Temp.dbo.MEDLEM" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Medlemsnr" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Medlemsnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Beskrivning" DataSetColumn="Beskrivning" />
              <Mapping SourceColumn="Short" DataSetColumn="Short" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MedlemTypeTableAdapter" GeneratorDataComponentClassName="MedlemTypeTableAdapter" Name="MedlemType" UserDataComponentName="MedlemTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBetaltTillOchMed" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetDataBetaltTillOchMed" GeneratorSourceName="FillBetaltTillOchMed" GetMethodModifier="Public" GetMethodName="GetDataBetaltTillOchMed" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetDataBetaltTillOchMed" UserSourceName="FillBetaltTillOchMed">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        dbo.MEDLEM.Medlemsnr, dbo.MEDLEM.Efternamn, dbo.MEDLEM.Förnamn, dbo.MEDLEM.Adress, dbo.MEDLEM.Postnr, dbo.MEDLEM.Postadress, 
                         dbo.MEDLEM.Telefonnr, dbo.MEDLEM.Telefonnr2, dbo.MEDLEM.Personnummer, dbo.MEDLEM.Email, dbo.MEDLEM.Betalt, dbo.MEDLEM.BetaltDatum, 
                         dbo.MEDLEM.Uppdrag, dbo.MEDLEM.IntradesDatum, dbo.MEDLEM.Region, dbo.MEDLEM.Kommentar, dbo.MEDLEM.Kön, dbo.MEDLEM.Inaktiv, 
                         dbo.MEDLEM.Utskick, dbo.MEDLEM.Andrad, dbo.MEDLEM.Skapad, dbo.MEDLEM.Funktionar, dbo.MEDLEM.AndradAv, dbo.MEDLEM.N3SportID, 
                         dbo.SSDFKATEGORI.Beskrivning AS SSDFKATEGORI, dbo.MEDLEMSTYP.Beskrivning AS MEDLEMSTYP
FROM            dbo.MEDLEM INNER JOIN
                         dbo.MEDLEMSTYP ON dbo.MEDLEM.Medlemstyp = dbo.MEDLEMSTYP.MedlemsTyp INNER JOIN
                         dbo.SSDFKATEGORI ON dbo.MEDLEM.SSDFKategori = dbo.SSDFKATEGORI.SSDFKategori
WHERE        (dbo.MEDLEM.Betalt = 1) AND (dbo.MEDLEM.BetaltDatum &gt; @TillOchMed) AND (dbo.MEDLEM.Inaktiv = 0)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="TillOchMed" ColumnName="BetaltDatum" DataSourceName="Osdk_Temp.dbo.MEDLEM" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@TillOchMed" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="BetaltDatum" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Medlemsnr" DataSetColumn="Medlemsnr" />
              <Mapping SourceColumn="Efternamn" DataSetColumn="Efternamn" />
              <Mapping SourceColumn="Förnamn" DataSetColumn="Förnamn" />
              <Mapping SourceColumn="Adress" DataSetColumn="Adress" />
              <Mapping SourceColumn="Postnr" DataSetColumn="Postnr" />
              <Mapping SourceColumn="Postadress" DataSetColumn="Postadress" />
              <Mapping SourceColumn="Telefonnr" DataSetColumn="Telefonnr" />
              <Mapping SourceColumn="Telefonnr2" DataSetColumn="Telefonnr2" />
              <Mapping SourceColumn="Personnummer" DataSetColumn="Personnummer" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Betalt" DataSetColumn="Betalt" />
              <Mapping SourceColumn="BetaltDatum" DataSetColumn="BetaltDatum" />
              <Mapping SourceColumn="Uppdrag" DataSetColumn="Uppdrag" />
              <Mapping SourceColumn="IntradesDatum" DataSetColumn="IntradesDatum" />
              <Mapping SourceColumn="Region" DataSetColumn="Region" />
              <Mapping SourceColumn="Kommentar" DataSetColumn="Kommentar" />
              <Mapping SourceColumn="Kön" DataSetColumn="Kön" />
              <Mapping SourceColumn="Inaktiv" DataSetColumn="Inaktiv" />
              <Mapping SourceColumn="Utskick" DataSetColumn="Utskick" />
              <Mapping SourceColumn="Andrad" DataSetColumn="Andrad" />
              <Mapping SourceColumn="Skapad" DataSetColumn="Skapad" />
              <Mapping SourceColumn="Funktionar" DataSetColumn="Funktionar" />
              <Mapping SourceColumn="AndradAv" DataSetColumn="AndradAv" />
              <Mapping SourceColumn="N3SportID" DataSetColumn="N3SportID" />
              <Mapping SourceColumn="SSDFKATEGORI" DataSetColumn="SSDFKATEGORI" />
              <Mapping SourceColumn="MEDLEMSTYP" DataSetColumn="MEDLEMSTYP" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="osdkConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByEpostAdress" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByEpostAdress" GeneratorSourceName="FillByEpostAdress" GetMethodModifier="Public" GetMethodName="GetDataByEpostAdress" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByEpostAdress" UserSourceName="FillByEpostAdress">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        dbo.MEDLEM.Medlemsnr, dbo.MEDLEM.Efternamn, dbo.MEDLEM.Förnamn, dbo.MEDLEM.Adress, dbo.MEDLEM.Postnr, dbo.MEDLEM.Postadress, 
                         dbo.MEDLEM.Telefonnr, dbo.MEDLEM.Telefonnr2, dbo.MEDLEM.Personnummer, dbo.MEDLEM.Email, dbo.MEDLEM.Betalt, dbo.MEDLEM.BetaltDatum, 
                         dbo.MEDLEM.Uppdrag, dbo.MEDLEM.IntradesDatum, dbo.MEDLEM.Region, dbo.MEDLEM.Kommentar, dbo.MEDLEM.Kön, dbo.MEDLEM.Inaktiv, 
                         dbo.MEDLEM.Utskick, dbo.MEDLEM.Andrad, dbo.MEDLEM.Skapad, dbo.MEDLEM.Funktionar, dbo.MEDLEM.AndradAv, dbo.MEDLEM.N3SportID, 
                         dbo.SSDFKATEGORI.Beskrivning AS SSDFKATEGORI, dbo.MEDLEMSTYP.Beskrivning AS MEDLEMSTYP
FROM            dbo.MEDLEM INNER JOIN
                         dbo.MEDLEMSTYP ON dbo.MEDLEM.Medlemstyp = dbo.MEDLEMSTYP.MedlemsTyp INNER JOIN
                         dbo.SSDFKATEGORI ON dbo.MEDLEM.SSDFKategori = dbo.SSDFKATEGORI.SSDFKategori
WHERE        (dbo.MEDLEM.Betalt = 1) AND (dbo.MEDLEM.Inaktiv = 0) AND (dbo.MEDLEM.Email LIKE '%' + @EpostAdress + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="EpostAdress" ColumnName="Email" DataSourceName="Osdk_Temp.dbo.MEDLEM" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@EpostAdress" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="OSDK" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="OSDK" msprop:Generator_DataSetName="OSDK" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="UTBILDNINGSNIVA" msprop:Generator_UserTableName="UTBILDNINGSNIVA" msprop:Generator_RowDeletedName="UTBILDNINGSNIVARowDeleted" msprop:Generator_RowChangedName="UTBILDNINGSNIVARowChanged" msprop:Generator_RowClassName="UTBILDNINGSNIVARow" msprop:Generator_RowChangingName="UTBILDNINGSNIVARowChanging" msprop:Generator_RowEvArgName="UTBILDNINGSNIVARowChangeEvent" msprop:Generator_RowEvHandlerName="UTBILDNINGSNIVARowChangeEventHandler" msprop:Generator_TableClassName="UTBILDNINGSNIVADataTable" msprop:Generator_TableVarName="tableUTBILDNINGSNIVA" msprop:Generator_RowDeletingName="UTBILDNINGSNIVARowDeleting" msprop:Generator_TablePropName="UTBILDNINGSNIVA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UtbildningsNiva" msprop:Generator_UserColumnName="UtbildningsNiva" msprop:Generator_ColumnVarNameInTable="columnUtbildningsNiva" msprop:Generator_ColumnPropNameInRow="UtbildningsNiva" msprop:Generator_ColumnPropNameInTable="UtbildningsNivaColumn" type="xs:int" />
              <xs:element name="Beskrivning" msprop:Generator_UserColumnName="Beskrivning" msprop:Generator_ColumnVarNameInTable="columnBeskrivning" msprop:Generator_ColumnPropNameInRow="Beskrivning" msprop:Generator_ColumnPropNameInTable="BeskrivningColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Short" msprop:Generator_UserColumnName="Short" msprop:Generator_ColumnVarNameInTable="columnShort" msprop:Generator_ColumnPropNameInRow="Short" msprop:Generator_ColumnPropNameInTable="ShortColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MEDLEMSTYP" msprop:Generator_UserTableName="MEDLEMSTYP" msprop:Generator_RowDeletedName="MEDLEMSTYPRowDeleted" msprop:Generator_RowChangedName="MEDLEMSTYPRowChanged" msprop:Generator_RowClassName="MEDLEMSTYPRow" msprop:Generator_RowChangingName="MEDLEMSTYPRowChanging" msprop:Generator_RowEvArgName="MEDLEMSTYPRowChangeEvent" msprop:Generator_RowEvHandlerName="MEDLEMSTYPRowChangeEventHandler" msprop:Generator_TableClassName="MEDLEMSTYPDataTable" msprop:Generator_TableVarName="tableMEDLEMSTYP" msprop:Generator_RowDeletingName="MEDLEMSTYPRowDeleting" msprop:Generator_TablePropName="MEDLEMSTYP">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MedlemsTyp" msprop:Generator_UserColumnName="MedlemsTyp" msprop:Generator_ColumnVarNameInTable="columnMedlemsTyp" msprop:Generator_ColumnPropNameInRow="MedlemsTyp" msprop:Generator_ColumnPropNameInTable="MedlemsTypColumn" type="xs:int" />
              <xs:element name="Beskrivning" msprop:Generator_UserColumnName="Beskrivning" msprop:Generator_ColumnVarNameInTable="columnBeskrivning" msprop:Generator_ColumnPropNameInRow="Beskrivning" msprop:Generator_ColumnPropNameInTable="BeskrivningColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Avgift" msprop:Generator_UserColumnName="Avgift" msprop:Generator_ColumnVarNameInTable="columnAvgift" msprop:Generator_ColumnPropNameInRow="Avgift" msprop:Generator_ColumnPropNameInTable="AvgiftColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Short" msprop:Generator_UserColumnName="Short" msprop:Generator_ColumnVarNameInTable="columnShort" msprop:Generator_ColumnPropNameInRow="Short" msprop:Generator_ColumnPropNameInTable="ShortColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SSDFKATEGORI" msprop:Generator_UserTableName="SSDFKATEGORI" msprop:Generator_RowDeletedName="SSDFKATEGORIRowDeleted" msprop:Generator_RowChangedName="SSDFKATEGORIRowChanged" msprop:Generator_RowClassName="SSDFKATEGORIRow" msprop:Generator_RowChangingName="SSDFKATEGORIRowChanging" msprop:Generator_RowEvArgName="SSDFKATEGORIRowChangeEvent" msprop:Generator_RowEvHandlerName="SSDFKATEGORIRowChangeEventHandler" msprop:Generator_TableClassName="SSDFKATEGORIDataTable" msprop:Generator_TableVarName="tableSSDFKATEGORI" msprop:Generator_RowDeletingName="SSDFKATEGORIRowDeleting" msprop:Generator_TablePropName="SSDFKATEGORI">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SSDFKategori" msprop:Generator_UserColumnName="SSDFKategori" msprop:Generator_ColumnVarNameInTable="columnSSDFKategori" msprop:Generator_ColumnPropNameInRow="SSDFKategori" msprop:Generator_ColumnPropNameInTable="SSDFKategoriColumn" type="xs:int" />
              <xs:element name="Beskrivning" msprop:Generator_UserColumnName="Beskrivning" msprop:Generator_ColumnVarNameInTable="columnBeskrivning" msprop:Generator_ColumnPropNameInRow="Beskrivning" msprop:Generator_ColumnPropNameInTable="BeskrivningColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Avgift" msprop:Generator_UserColumnName="Avgift" msprop:Generator_ColumnVarNameInTable="columnAvgift" msprop:Generator_ColumnPropNameInRow="Avgift" msprop:Generator_ColumnPropNameInTable="AvgiftColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Email" msprop:Generator_UserTableName="Email" msprop:Generator_RowDeletedName="EmailRowDeleted" msprop:Generator_RowChangedName="EmailRowChanged" msprop:Generator_RowClassName="EmailRow" msprop:Generator_RowChangingName="EmailRowChanging" msprop:Generator_RowEvArgName="EmailRowChangeEvent" msprop:Generator_RowEvHandlerName="EmailRowChangeEventHandler" msprop:Generator_TableClassName="EmailDataTable" msprop:Generator_TableVarName="tableEmail" msprop:Generator_RowDeletingName="EmailRowDeleting" msprop:Generator_TablePropName="Email">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="REL_MEDLEM_UTBILDNINGSNIVA" msprop:Generator_UserTableName="REL_MEDLEM_UTBILDNINGSNIVA" msprop:Generator_RowDeletedName="REL_MEDLEM_UTBILDNINGSNIVARowDeleted" msprop:Generator_RowChangedName="REL_MEDLEM_UTBILDNINGSNIVARowChanged" msprop:Generator_RowClassName="REL_MEDLEM_UTBILDNINGSNIVARow" msprop:Generator_RowChangingName="REL_MEDLEM_UTBILDNINGSNIVARowChanging" msprop:Generator_RowEvArgName="REL_MEDLEM_UTBILDNINGSNIVARowChangeEvent" msprop:Generator_RowEvHandlerName="REL_MEDLEM_UTBILDNINGSNIVARowChangeEventHandler" msprop:Generator_TableClassName="REL_MEDLEM_UTBILDNINGSNIVADataTable" msprop:Generator_TableVarName="tableREL_MEDLEM_UTBILDNINGSNIVA" msprop:Generator_RowDeletingName="REL_MEDLEM_UTBILDNINGSNIVARowDeleting" msprop:Generator_TablePropName="REL_MEDLEM_UTBILDNINGSNIVA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Medlemsnr" msprop:Generator_UserColumnName="Medlemsnr" msprop:Generator_ColumnPropNameInRow="Medlemsnr" msprop:Generator_ColumnVarNameInTable="columnMedlemsnr" msprop:Generator_ColumnPropNameInTable="MedlemsnrColumn" type="xs:int" />
              <xs:element name="UtbildningsNiva" msprop:Generator_UserColumnName="UtbildningsNiva" msprop:Generator_ColumnPropNameInRow="UtbildningsNiva" msprop:Generator_ColumnVarNameInTable="columnUtbildningsNiva" msprop:Generator_ColumnPropNameInTable="UtbildningsNivaColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MEDLEM" msprop:Generator_UserTableName="MEDLEM" msprop:Generator_RowDeletedName="MEDLEMRowDeleted" msprop:Generator_RowChangedName="MEDLEMRowChanged" msprop:Generator_RowClassName="MEDLEMRow" msprop:Generator_RowChangingName="MEDLEMRowChanging" msprop:Generator_RowEvArgName="MEDLEMRowChangeEvent" msprop:Generator_RowEvHandlerName="MEDLEMRowChangeEventHandler" msprop:Generator_TableClassName="MEDLEMDataTable" msprop:Generator_TableVarName="tableMEDLEM" msprop:Generator_RowDeletingName="MEDLEMRowDeleting" msprop:Generator_TablePropName="MEDLEM">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Medlemsnr" msprop:Generator_UserColumnName="Medlemsnr" msprop:Generator_ColumnPropNameInRow="Medlemsnr" msprop:Generator_ColumnVarNameInTable="columnMedlemsnr" msprop:Generator_ColumnPropNameInTable="MedlemsnrColumn" type="xs:int" />
              <xs:element name="Streckkod" msprop:Generator_UserColumnName="Streckkod" msprop:Generator_ColumnPropNameInRow="Streckkod" msprop:Generator_ColumnVarNameInTable="columnStreckkod" msprop:Generator_ColumnPropNameInTable="StreckkodColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Efternamn" msprop:Generator_UserColumnName="Efternamn" msprop:Generator_ColumnPropNameInRow="Efternamn" msprop:Generator_ColumnVarNameInTable="columnEfternamn" msprop:Generator_ColumnPropNameInTable="EfternamnColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Förnamn" msprop:Generator_UserColumnName="Förnamn" msprop:Generator_ColumnPropNameInRow="Förnamn" msprop:Generator_ColumnVarNameInTable="columnFörnamn" msprop:Generator_ColumnPropNameInTable="FörnamnColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Adress" msprop:Generator_UserColumnName="Adress" msprop:Generator_ColumnPropNameInRow="Adress" msprop:Generator_ColumnVarNameInTable="columnAdress" msprop:Generator_ColumnPropNameInTable="AdressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postnr" msprop:Generator_UserColumnName="Postnr" msprop:Generator_ColumnPropNameInRow="Postnr" msprop:Generator_ColumnVarNameInTable="columnPostnr" msprop:Generator_ColumnPropNameInTable="PostnrColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postadress" msprop:Generator_UserColumnName="Postadress" msprop:Generator_ColumnPropNameInRow="Postadress" msprop:Generator_ColumnVarNameInTable="columnPostadress" msprop:Generator_ColumnPropNameInTable="PostadressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefonnr" msprop:Generator_UserColumnName="Telefonnr" msprop:Generator_ColumnPropNameInRow="Telefonnr" msprop:Generator_ColumnVarNameInTable="columnTelefonnr" msprop:Generator_ColumnPropNameInTable="TelefonnrColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefonnr2" msprop:Generator_UserColumnName="Telefonnr2" msprop:Generator_ColumnPropNameInRow="Telefonnr2" msprop:Generator_ColumnVarNameInTable="columnTelefonnr2" msprop:Generator_ColumnPropNameInTable="Telefonnr2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Personnummer" msprop:Generator_UserColumnName="Personnummer" msprop:Generator_ColumnPropNameInRow="Personnummer" msprop:Generator_ColumnVarNameInTable="columnPersonnummer" msprop:Generator_ColumnPropNameInTable="PersonnummerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Medlemstyp" msprop:Generator_UserColumnName="Medlemstyp" msprop:Generator_ColumnPropNameInRow="Medlemstyp" msprop:Generator_ColumnVarNameInTable="columnMedlemstyp" msprop:Generator_ColumnPropNameInTable="MedlemstypColumn" type="xs:int" />
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Betalt" msprop:Generator_UserColumnName="Betalt" msprop:Generator_ColumnPropNameInRow="Betalt" msprop:Generator_ColumnVarNameInTable="columnBetalt" msprop:Generator_ColumnPropNameInTable="BetaltColumn" type="xs:int" />
              <xs:element name="BetaltDatum" msprop:Generator_UserColumnName="BetaltDatum" msprop:Generator_ColumnPropNameInRow="BetaltDatum" msprop:Generator_ColumnVarNameInTable="columnBetaltDatum" msprop:Generator_ColumnPropNameInTable="BetaltDatumColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="SSDFKategori" msprop:Generator_UserColumnName="SSDFKategori" msprop:Generator_ColumnPropNameInRow="SSDFKategori" msprop:Generator_ColumnVarNameInTable="columnSSDFKategori" msprop:Generator_ColumnPropNameInTable="SSDFKategoriColumn" type="xs:int" />
              <xs:element name="Uppdrag" msprop:Generator_UserColumnName="Uppdrag" msprop:Generator_ColumnPropNameInRow="Uppdrag" msprop:Generator_ColumnVarNameInTable="columnUppdrag" msprop:Generator_ColumnPropNameInTable="UppdragColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IntradesDatum" msprop:Generator_UserColumnName="IntradesDatum" msprop:Generator_ColumnPropNameInRow="IntradesDatum" msprop:Generator_ColumnVarNameInTable="columnIntradesDatum" msprop:Generator_ColumnPropNameInTable="IntradesDatumColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Region" msprop:Generator_UserColumnName="Region" msprop:Generator_ColumnPropNameInRow="Region" msprop:Generator_ColumnVarNameInTable="columnRegion" msprop:Generator_ColumnPropNameInTable="RegionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Kommentar" msprop:Generator_UserColumnName="Kommentar" msprop:Generator_ColumnPropNameInRow="Kommentar" msprop:Generator_ColumnVarNameInTable="columnKommentar" msprop:Generator_ColumnPropNameInTable="KommentarColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Kön" msprop:Generator_UserColumnName="Kön" msprop:Generator_ColumnPropNameInRow="Kön" msprop:Generator_ColumnVarNameInTable="columnKön" msprop:Generator_ColumnPropNameInTable="KönColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Inaktiv" msprop:Generator_UserColumnName="Inaktiv" msprop:Generator_ColumnPropNameInRow="Inaktiv" msprop:Generator_ColumnVarNameInTable="columnInaktiv" msprop:Generator_ColumnPropNameInTable="InaktivColumn" type="xs:int" />
              <xs:element name="Utskick" msprop:Generator_UserColumnName="Utskick" msprop:Generator_ColumnPropNameInRow="Utskick" msprop:Generator_ColumnVarNameInTable="columnUtskick" msprop:Generator_ColumnPropNameInTable="UtskickColumn" type="xs:int" />
              <xs:element name="Andrad" msprop:Generator_UserColumnName="Andrad" msprop:Generator_ColumnPropNameInRow="Andrad" msprop:Generator_ColumnVarNameInTable="columnAndrad" msprop:Generator_ColumnPropNameInTable="AndradColumn" type="xs:dateTime" />
              <xs:element name="Skapad" msprop:Generator_UserColumnName="Skapad" msprop:Generator_ColumnPropNameInRow="Skapad" msprop:Generator_ColumnVarNameInTable="columnSkapad" msprop:Generator_ColumnPropNameInTable="SkapadColumn" type="xs:dateTime" />
              <xs:element name="Funktionar" msprop:Generator_UserColumnName="Funktionar" msprop:Generator_ColumnPropNameInRow="Funktionar" msprop:Generator_ColumnVarNameInTable="columnFunktionar" msprop:Generator_ColumnPropNameInTable="FunktionarColumn" type="xs:int" />
              <xs:element name="AndradAv" msprop:Generator_UserColumnName="AndradAv" msprop:Generator_ColumnPropNameInRow="AndradAv" msprop:Generator_ColumnVarNameInTable="columnAndradAv" msprop:Generator_ColumnPropNameInTable="AndradAvColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Betalt2003" msprop:Generator_UserColumnName="Betalt2003" msprop:Generator_ColumnPropNameInRow="Betalt2003" msprop:Generator_ColumnVarNameInTable="columnBetalt2003" msprop:Generator_ColumnPropNameInTable="Betalt2003Column" type="xs:int" />
              <xs:element name="Betalt2004" msprop:Generator_UserColumnName="Betalt2004" msprop:Generator_ColumnPropNameInRow="Betalt2004" msprop:Generator_ColumnVarNameInTable="columnBetalt2004" msprop:Generator_ColumnPropNameInTable="Betalt2004Column" type="xs:int" />
              <xs:element name="Betalt2005" msprop:Generator_UserColumnName="Betalt2005" msprop:Generator_ColumnPropNameInRow="Betalt2005" msprop:Generator_ColumnVarNameInTable="columnBetalt2005" msprop:Generator_ColumnPropNameInTable="Betalt2005Column" type="xs:int" />
              <xs:element name="Betalt2006" msprop:Generator_UserColumnName="Betalt2006" msprop:Generator_ColumnPropNameInRow="Betalt2006" msprop:Generator_ColumnVarNameInTable="columnBetalt2006" msprop:Generator_ColumnPropNameInTable="Betalt2006Column" type="xs:int" />
              <xs:element name="Betalt2007" msprop:Generator_UserColumnName="Betalt2007" msprop:Generator_ColumnPropNameInRow="Betalt2007" msprop:Generator_ColumnVarNameInTable="columnBetalt2007" msprop:Generator_ColumnPropNameInTable="Betalt2007Column" type="xs:int" />
              <xs:element name="Betalt2008" msprop:Generator_UserColumnName="Betalt2008" msprop:Generator_ColumnPropNameInRow="Betalt2008" msprop:Generator_ColumnVarNameInTable="columnBetalt2008" msprop:Generator_ColumnPropNameInTable="Betalt2008Column" type="xs:int" />
              <xs:element name="N3SportID" msprop:Generator_UserColumnName="N3SportID" msprop:Generator_ColumnPropNameInRow="N3SportID" msprop:Generator_ColumnVarNameInTable="columnN3SportID" msprop:Generator_ColumnPropNameInTable="N3SportIDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MatrikelMedlem" msprop:Generator_UserTableName="MatrikelMedlem" msprop:Generator_RowDeletedName="MatrikelMedlemRowDeleted" msprop:Generator_RowChangedName="MatrikelMedlemRowChanged" msprop:Generator_RowClassName="MatrikelMedlemRow" msprop:Generator_RowChangingName="MatrikelMedlemRowChanging" msprop:Generator_RowEvArgName="MatrikelMedlemRowChangeEvent" msprop:Generator_RowEvHandlerName="MatrikelMedlemRowChangeEventHandler" msprop:Generator_TableClassName="MatrikelMedlemDataTable" msprop:Generator_TableVarName="tableMatrikelMedlem" msprop:Generator_RowDeletingName="MatrikelMedlemRowDeleting" msprop:Generator_TablePropName="MatrikelMedlem">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MEDLEMSTYP" msprop:Generator_UserColumnName="MEDLEMSTYP" msprop:Generator_ColumnPropNameInRow="MEDLEMSTYP" msprop:Generator_ColumnVarNameInTable="columnMEDLEMSTYP" msprop:Generator_ColumnPropNameInTable="MEDLEMSTYPColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SSDFKATEGORI" msprop:Generator_UserColumnName="SSDFKATEGORI" msprop:Generator_ColumnPropNameInRow="SSDFKATEGORI" msprop:Generator_ColumnVarNameInTable="columnSSDFKATEGORI" msprop:Generator_ColumnPropNameInTable="SSDFKATEGORIColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Efternamn" msprop:Generator_UserColumnName="Efternamn" msprop:Generator_ColumnPropNameInRow="Efternamn" msprop:Generator_ColumnVarNameInTable="columnEfternamn" msprop:Generator_ColumnPropNameInTable="EfternamnColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Förnamn" msprop:Generator_UserColumnName="Förnamn" msprop:Generator_ColumnPropNameInRow="Förnamn" msprop:Generator_ColumnVarNameInTable="columnFörnamn" msprop:Generator_ColumnPropNameInTable="FörnamnColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Adress" msprop:Generator_UserColumnName="Adress" msprop:Generator_ColumnPropNameInRow="Adress" msprop:Generator_ColumnVarNameInTable="columnAdress" msprop:Generator_ColumnPropNameInTable="AdressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postnr" msprop:Generator_UserColumnName="Postnr" msprop:Generator_ColumnPropNameInRow="Postnr" msprop:Generator_ColumnVarNameInTable="columnPostnr" msprop:Generator_ColumnPropNameInTable="PostnrColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postadress" msprop:Generator_UserColumnName="Postadress" msprop:Generator_ColumnPropNameInRow="Postadress" msprop:Generator_ColumnVarNameInTable="columnPostadress" msprop:Generator_ColumnPropNameInTable="PostadressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefonnr" msprop:Generator_UserColumnName="Telefonnr" msprop:Generator_ColumnPropNameInRow="Telefonnr" msprop:Generator_ColumnVarNameInTable="columnTelefonnr" msprop:Generator_ColumnPropNameInTable="TelefonnrColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefonnr2" msprop:Generator_UserColumnName="Telefonnr2" msprop:Generator_ColumnPropNameInRow="Telefonnr2" msprop:Generator_ColumnVarNameInTable="columnTelefonnr2" msprop:Generator_ColumnPropNameInTable="Telefonnr2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Uppdrag" msprop:Generator_UserColumnName="Uppdrag" msprop:Generator_ColumnPropNameInRow="Uppdrag" msprop:Generator_ColumnVarNameInTable="columnUppdrag" msprop:Generator_ColumnPropNameInTable="UppdragColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Medlemsnr" msprop:Generator_UserColumnName="Medlemsnr" msprop:Generator_ColumnVarNameInTable="columnMedlemsnr" msprop:Generator_ColumnPropNameInRow="Medlemsnr" msprop:Generator_ColumnPropNameInTable="MedlemsnrColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MedlemType" msprop:Generator_UserTableName="MedlemType" msprop:Generator_RowDeletedName="MedlemTypeRowDeleted" msprop:Generator_TableClassName="MedlemTypeDataTable" msprop:Generator_RowChangedName="MedlemTypeRowChanged" msprop:Generator_RowClassName="MedlemTypeRow" msprop:Generator_RowChangingName="MedlemTypeRowChanging" msprop:Generator_RowEvArgName="MedlemTypeRowChangeEvent" msprop:Generator_RowEvHandlerName="MedlemTypeRowChangeEventHandler" msprop:Generator_TablePropName="MedlemType" msprop:Generator_TableVarName="tableMedlemType" msprop:Generator_RowDeletingName="MedlemTypeRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Medlemsnr" msprop:Generator_UserColumnName="Medlemsnr" msprop:Generator_ColumnPropNameInRow="Medlemsnr" msprop:Generator_ColumnVarNameInTable="columnMedlemsnr" msprop:Generator_ColumnPropNameInTable="MedlemsnrColumn" type="xs:int" />
              <xs:element name="Efternamn" msprop:Generator_UserColumnName="Efternamn" msprop:Generator_ColumnPropNameInRow="Efternamn" msprop:Generator_ColumnVarNameInTable="columnEfternamn" msprop:Generator_ColumnPropNameInTable="EfternamnColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Förnamn" msprop:Generator_UserColumnName="Förnamn" msprop:Generator_ColumnPropNameInRow="Förnamn" msprop:Generator_ColumnVarNameInTable="columnFörnamn" msprop:Generator_ColumnPropNameInTable="FörnamnColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Adress" msprop:Generator_UserColumnName="Adress" msprop:Generator_ColumnPropNameInRow="Adress" msprop:Generator_ColumnVarNameInTable="columnAdress" msprop:Generator_ColumnPropNameInTable="AdressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postnr" msprop:Generator_UserColumnName="Postnr" msprop:Generator_ColumnPropNameInRow="Postnr" msprop:Generator_ColumnVarNameInTable="columnPostnr" msprop:Generator_ColumnPropNameInTable="PostnrColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postadress" msprop:Generator_UserColumnName="Postadress" msprop:Generator_ColumnPropNameInRow="Postadress" msprop:Generator_ColumnVarNameInTable="columnPostadress" msprop:Generator_ColumnPropNameInTable="PostadressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefonnr" msprop:Generator_UserColumnName="Telefonnr" msprop:Generator_ColumnPropNameInRow="Telefonnr" msprop:Generator_ColumnVarNameInTable="columnTelefonnr" msprop:Generator_ColumnPropNameInTable="TelefonnrColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefonnr2" msprop:Generator_UserColumnName="Telefonnr2" msprop:Generator_ColumnPropNameInRow="Telefonnr2" msprop:Generator_ColumnVarNameInTable="columnTelefonnr2" msprop:Generator_ColumnPropNameInTable="Telefonnr2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Personnummer" msprop:Generator_UserColumnName="Personnummer" msprop:Generator_ColumnPropNameInRow="Personnummer" msprop:Generator_ColumnVarNameInTable="columnPersonnummer" msprop:Generator_ColumnPropNameInTable="PersonnummerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Betalt" msprop:Generator_UserColumnName="Betalt" msprop:Generator_ColumnPropNameInRow="Betalt" msprop:Generator_ColumnVarNameInTable="columnBetalt" msprop:Generator_ColumnPropNameInTable="BetaltColumn" type="xs:int" />
              <xs:element name="BetaltDatum" msprop:Generator_UserColumnName="BetaltDatum" msprop:Generator_ColumnPropNameInRow="BetaltDatum" msprop:Generator_ColumnVarNameInTable="columnBetaltDatum" msprop:Generator_ColumnPropNameInTable="BetaltDatumColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Uppdrag" msprop:Generator_UserColumnName="Uppdrag" msprop:Generator_ColumnPropNameInRow="Uppdrag" msprop:Generator_ColumnVarNameInTable="columnUppdrag" msprop:Generator_ColumnPropNameInTable="UppdragColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IntradesDatum" msprop:Generator_UserColumnName="IntradesDatum" msprop:Generator_ColumnPropNameInRow="IntradesDatum" msprop:Generator_ColumnVarNameInTable="columnIntradesDatum" msprop:Generator_ColumnPropNameInTable="IntradesDatumColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Region" msprop:Generator_UserColumnName="Region" msprop:Generator_ColumnPropNameInRow="Region" msprop:Generator_ColumnVarNameInTable="columnRegion" msprop:Generator_ColumnPropNameInTable="RegionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Kommentar" msprop:Generator_UserColumnName="Kommentar" msprop:Generator_ColumnPropNameInRow="Kommentar" msprop:Generator_ColumnVarNameInTable="columnKommentar" msprop:Generator_ColumnPropNameInTable="KommentarColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Kön" msprop:Generator_UserColumnName="Kön" msprop:Generator_ColumnPropNameInRow="Kön" msprop:Generator_ColumnVarNameInTable="columnKön" msprop:Generator_ColumnPropNameInTable="KönColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Inaktiv" msprop:Generator_UserColumnName="Inaktiv" msprop:Generator_ColumnPropNameInRow="Inaktiv" msprop:Generator_ColumnVarNameInTable="columnInaktiv" msprop:Generator_ColumnPropNameInTable="InaktivColumn" type="xs:int" />
              <xs:element name="Utskick" msprop:Generator_UserColumnName="Utskick" msprop:Generator_ColumnPropNameInRow="Utskick" msprop:Generator_ColumnVarNameInTable="columnUtskick" msprop:Generator_ColumnPropNameInTable="UtskickColumn" type="xs:int" />
              <xs:element name="Andrad" msprop:Generator_UserColumnName="Andrad" msprop:Generator_ColumnPropNameInRow="Andrad" msprop:Generator_ColumnVarNameInTable="columnAndrad" msprop:Generator_ColumnPropNameInTable="AndradColumn" type="xs:dateTime" />
              <xs:element name="Skapad" msprop:Generator_UserColumnName="Skapad" msprop:Generator_ColumnPropNameInRow="Skapad" msprop:Generator_ColumnVarNameInTable="columnSkapad" msprop:Generator_ColumnPropNameInTable="SkapadColumn" type="xs:dateTime" />
              <xs:element name="Funktionar" msprop:Generator_UserColumnName="Funktionar" msprop:Generator_ColumnPropNameInRow="Funktionar" msprop:Generator_ColumnVarNameInTable="columnFunktionar" msprop:Generator_ColumnPropNameInTable="FunktionarColumn" type="xs:int" />
              <xs:element name="AndradAv" msprop:Generator_UserColumnName="AndradAv" msprop:Generator_ColumnPropNameInRow="AndradAv" msprop:Generator_ColumnVarNameInTable="columnAndradAv" msprop:Generator_ColumnPropNameInTable="AndradAvColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="N3SportID" msprop:Generator_UserColumnName="N3SportID" msprop:Generator_ColumnPropNameInRow="N3SportID" msprop:Generator_ColumnVarNameInTable="columnN3SportID" msprop:Generator_ColumnPropNameInTable="N3SportIDColumn" type="xs:int" />
              <xs:element name="SSDFKATEGORI" msprop:Generator_UserColumnName="SSDFKATEGORI" msprop:Generator_ColumnPropNameInRow="SSDFKATEGORI" msprop:Generator_ColumnVarNameInTable="columnSSDFKATEGORI" msprop:Generator_ColumnPropNameInTable="SSDFKATEGORIColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MEDLEMSTYP" msprop:Generator_UserColumnName="MEDLEMSTYP" msprop:Generator_ColumnPropNameInRow="MEDLEMSTYP" msprop:Generator_ColumnVarNameInTable="columnMEDLEMSTYP" msprop:Generator_ColumnPropNameInTable="MEDLEMSTYPColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MatrikelUtbildningsniva" msprop:Generator_UserTableName="MatrikelUtbildningsniva" msprop:Generator_RowDeletedName="MatrikelUtbildningsnivaRowDeleted" msprop:Generator_RowChangedName="MatrikelUtbildningsnivaRowChanged" msprop:Generator_RowClassName="MatrikelUtbildningsnivaRow" msprop:Generator_RowChangingName="MatrikelUtbildningsnivaRowChanging" msprop:Generator_RowEvArgName="MatrikelUtbildningsnivaRowChangeEvent" msprop:Generator_RowEvHandlerName="MatrikelUtbildningsnivaRowChangeEventHandler" msprop:Generator_TableClassName="MatrikelUtbildningsnivaDataTable" msprop:Generator_TableVarName="tableMatrikelUtbildningsniva" msprop:Generator_RowDeletingName="MatrikelUtbildningsnivaRowDeleting" msprop:Generator_TablePropName="MatrikelUtbildningsniva">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Beskrivning" msprop:Generator_UserColumnName="Beskrivning" msprop:Generator_ColumnPropNameInRow="Beskrivning" msprop:Generator_ColumnVarNameInTable="columnBeskrivning" msprop:Generator_ColumnPropNameInTable="BeskrivningColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Short" msprop:Generator_UserColumnName="Short" msprop:Generator_ColumnPropNameInRow="Short" msprop:Generator_ColumnVarNameInTable="columnShort" msprop:Generator_ColumnPropNameInTable="ShortColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UTBILDNINGSNIVA" />
      <xs:field xpath="mstns:UtbildningsNiva" />
    </xs:unique>
    <xs:unique name="MEDLEMSTYP_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MEDLEMSTYP" />
      <xs:field xpath="mstns:MedlemsTyp" />
    </xs:unique>
    <xs:unique name="SSDFKATEGORI_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SSDFKATEGORI" />
      <xs:field xpath="mstns:SSDFKategori" />
    </xs:unique>
    <xs:unique name="MEDLEM_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MEDLEM" />
      <xs:field xpath="mstns:Medlemsnr" />
    </xs:unique>
    <xs:unique name="MatrikelMedlem_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MatrikelMedlem" />
      <xs:field xpath="mstns:Medlemsnr" />
    </xs:unique>
    <xs:unique name="MedlemType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MedlemType" />
      <xs:field xpath="mstns:Medlemsnr" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_REL_MEDLEM_UTBILDNINGSNIVA_UTBILDNINGSNIVA" msdata:parent="UTBILDNINGSNIVA" msdata:child="REL_MEDLEM_UTBILDNINGSNIVA" msdata:parentkey="UtbildningsNiva" msdata:childkey="UtbildningsNiva" msprop:Generator_UserRelationName="FK_REL_MEDLEM_UTBILDNINGSNIVA_UTBILDNINGSNIVA" msprop:Generator_RelationVarName="relationFK_REL_MEDLEM_UTBILDNINGSNIVA_UTBILDNINGSNIVA" msprop:Generator_UserChildTable="REL_MEDLEM_UTBILDNINGSNIVA" msprop:Generator_UserParentTable="UTBILDNINGSNIVA" msprop:Generator_ParentPropName="UTBILDNINGSNIVARow" msprop:Generator_ChildPropName="GetREL_MEDLEM_UTBILDNINGSNIVARows" />
      <msdata:Relationship name="FK_REL_MEDLEM_UTBILDNINGSNIVA_MEDLEM" msdata:parent="MEDLEM" msdata:child="REL_MEDLEM_UTBILDNINGSNIVA" msdata:parentkey="Medlemsnr" msdata:childkey="Medlemsnr" msprop:Generator_UserRelationName="FK_REL_MEDLEM_UTBILDNINGSNIVA_MEDLEM" msprop:Generator_RelationVarName="relationFK_REL_MEDLEM_UTBILDNINGSNIVA_MEDLEM" msprop:Generator_UserChildTable="REL_MEDLEM_UTBILDNINGSNIVA" msprop:Generator_UserParentTable="MEDLEM" msprop:Generator_ParentPropName="MEDLEMRow" msprop:Generator_ChildPropName="GetREL_MEDLEM_UTBILDNINGSNIVARows" />
      <msdata:Relationship name="FK_MEDLEM_MEDLEMSTYP" msdata:parent="MEDLEMSTYP" msdata:child="MEDLEM" msdata:parentkey="MedlemsTyp" msdata:childkey="Medlemstyp" msprop:Generator_UserRelationName="FK_MEDLEM_MEDLEMSTYP" msprop:Generator_RelationVarName="relationFK_MEDLEM_MEDLEMSTYP" msprop:Generator_UserChildTable="MEDLEM" msprop:Generator_UserParentTable="MEDLEMSTYP" msprop:Generator_ParentPropName="MEDLEMSTYPRow" msprop:Generator_ChildPropName="GetMEDLEMRows" />
      <msdata:Relationship name="FK_MEDLEM_SSDFKATEGORI" msdata:parent="SSDFKATEGORI" msdata:child="MEDLEM" msdata:parentkey="SSDFKategori" msdata:childkey="SSDFKategori" msprop:Generator_UserRelationName="FK_MEDLEM_SSDFKATEGORI" msprop:Generator_RelationVarName="relationFK_MEDLEM_SSDFKATEGORI" msprop:Generator_UserChildTable="MEDLEM" msprop:Generator_UserParentTable="SSDFKATEGORI" msprop:Generator_ParentPropName="SSDFKATEGORIRow" msprop:Generator_ChildPropName="GetMEDLEMRows" />
      <msdata:Relationship name="FK_REL_MEDLEM_UTBILDNINGSNIVA_MEDLEM1" msdata:parent="MatrikelMedlem" msdata:child="REL_MEDLEM_UTBILDNINGSNIVA" msdata:parentkey="Medlemsnr" msdata:childkey="Medlemsnr" msprop:Generator_UserRelationName="FK_REL_MEDLEM_UTBILDNINGSNIVA_MEDLEM1" msprop:Generator_RelationVarName="relationFK_REL_MEDLEM_UTBILDNINGSNIVA_MEDLEM1" msprop:Generator_UserChildTable="REL_MEDLEM_UTBILDNINGSNIVA" msprop:Generator_UserParentTable="MatrikelMedlem" msprop:Generator_ParentPropName="MatrikelMedlemRow" msprop:Generator_ChildPropName="GetREL_MEDLEM_UTBILDNINGSNIVARows" />
      <msdata:Relationship name="FK_REL_MEDLEM_UTBILDNINGSNIVA_MEDLEM3" msdata:parent="MedlemType" msdata:child="REL_MEDLEM_UTBILDNINGSNIVA" msdata:parentkey="Medlemsnr" msdata:childkey="Medlemsnr" msprop:Generator_UserRelationName="FK_REL_MEDLEM_UTBILDNINGSNIVA_MEDLEM3" msprop:Generator_RelationVarName="relationFK_REL_MEDLEM_UTBILDNINGSNIVA_MEDLEM3" msprop:Generator_UserChildTable="REL_MEDLEM_UTBILDNINGSNIVA" msprop:Generator_UserParentTable="MedlemType" msprop:Generator_ParentPropName="MedlemTypeRow" msprop:Generator_ChildPropName="GetREL_MEDLEM_UTBILDNINGSNIVARows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>